本文整理汇总了C#中IP.Core.IPUserService.CStoredProc.addDatetimeOutputParam方法的典型用法代码示例。如果您正苦于以下问题:C# CStoredProc.addDatetimeOutputParam方法的具体用法?C# CStoredProc.addDatetimeOutputParam怎么用?C# CStoredProc.addDatetimeOutputParam使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IP.Core.IPUserService.CStoredProc
的用法示例。
在下文中一共展示了CStoredProc.addDatetimeOutputParam方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: get_thoi_diem_can_hoan_thanh
public DateTime get_thoi_diem_can_hoan_thanh(string time)
{
string v_output = "";
CStoredProc v_cstore = new CStoredProc("pr_get_thoi_diem_can_hoan_thanh");
v_cstore.addNVarcharInputParam("@string_time", time);
SqlParameter v_result = v_cstore.addDatetimeOutputParam("@thoi_diem_can_hoan_thanh", v_output);
v_cstore.ExecuteCommand(this);
return (DateTime)v_result.Value;
}
示例2: get_co_so_dinh_muc_ap_dung_tu_ngay
public void get_co_so_dinh_muc_ap_dung_tu_ngay(decimal ip_id_trung_tam, decimal ip_id_loai_dinh_muc
, DateTime ip_from_date, DateTime ip_to_date
, ref decimal op_id_co_so_dinh_muc, ref DateTime op_ap_dung_tu_ngay
, ref string op_ten_co_so_dinh_muc)
{
CStoredProc v_proc = new CStoredProc("pr_get_co_so_dinh_muc_ap_dung_tu_ngay");
v_proc.addDecimalInputParam("@ID_TRUNG_TAM", ip_id_trung_tam);
v_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", ip_id_loai_dinh_muc);
v_proc.addDatetimeInputParam("@FROM_DATE", ip_from_date);
v_proc.addDatetimeInputParam("@TO_DATE", ip_to_date);
SqlParameter v_obj_id_co_so_dinh_muc = v_proc.addDecimalOutputParam("@ID_CO_SO_DINH_MUC", -1);
SqlParameter v_obj_ten_co_so_dinh_muc = v_proc.addNVarcharOutputParam("@TEN_CO_SO_DINH_MUC", -1);
SqlParameter v_obj_ap_dung_tu_ngay = v_proc.addDatetimeOutputParam("@AP_DUNG_TU_NGAY", -1);
v_proc.ExecuteCommand(this);
op_id_co_so_dinh_muc = CIPConvert.ToDecimal(v_obj_id_co_so_dinh_muc.Value);
string temp = v_obj_ap_dung_tu_ngay.Value.ToString();
if(temp != "") {
temp = temp.Substring(0, temp.IndexOf(" "));
op_ap_dung_tu_ngay = CIPConvert.ToDatetime(temp);
}
if(v_obj_ten_co_so_dinh_muc.Value.ToString() != "") {
op_ten_co_so_dinh_muc = CIPConvert.ToStr(v_obj_ten_co_so_dinh_muc.Value);
}
}
示例3: get_ap_dung_tu_ngay
public string get_ap_dung_tu_ngay(decimal ip_id_loai_dinh_muc, decimal ip_id_loai_co_so_dinh_muc)
{
CStoredProc v_proc = new CStoredProc("pr_get_ap_dung_tu_ngay_max");
v_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", ip_id_loai_dinh_muc);
v_proc.addDecimalInputParam("@ID_LOAI_CO_SO_DINH_MUC", ip_id_loai_co_so_dinh_muc);
SqlParameter v_ap_dung_tu_ngay = v_proc.addDatetimeOutputParam("@AP_DUNG_TU_NGAY", -1);
v_proc.ExecuteCommand(this);
return v_ap_dung_tu_ngay.Value.ToString();
}