////2012.05.11修改(上传二张表的ds 处理加到Q_ZB_FS_FX表里)这个没用了
//public string Q_ZB_FS_FX_add(DataSet DS_Fwxother, DataSet DS_Qskydfjrb)
//{
// BLL.Fwx_other B_Fwx_other = new BLL.Fwx_other();
// BLL.Qskyd_fjrb B_Qskydfjrb = new BLL.Qskyd_fjrb();
// string s = common_file.common_app.get_failure;
// if (Fwx_other_UploadDS(DS_Fwxother) == common_file.common_app.get_suc)//添加到远程的Fwx_other表成功
// {
// DataSet ds_wxf = B_Fwx_other.GetList("1=1");
// if (Add_Q_ZB_FS_FX(ds_wxf, 2) == common_file.common_app.get_suc)//添加到Q_ZB_Fs_fx表里
// {
// s = common_file.common_app.get_suc;
// }
// }
// if (Qskyd_fjrb_UploadDS(DS_Qskydfjrb) == common_file.common_app.get_suc)//添加到远程的Qskyd_fjrb表成功
// {
// DataSet ds = B_Qskydfjrb.GetList("1=1");
// if (Add_Q_ZB_FS_FX(ds, 1) == common_file.common_app.get_suc)//添加到Q_ZB_Fs_fx表里
// {
// s = common_file.common_app.get_suc;
// }
// }
// return s;
//}
//2012.05.11修改上传二张表的DS,然后加到各自的临时表 Qskyd_fjrb_temp,
public string Qskyd_fjrb_temp_ADD(DataSet DS_Fwxother, DataSet DS_Qskydfjrb)
{
BLL.Fwx_other_temp B_Fwx_other = new BLL.Fwx_other_temp();
BLL.Qskyd_fjrb_temp B_Qskydfjrb = new BLL.Qskyd_fjrb_temp();
string s = common_file.common_app.get_failure;
string stryydh = DS_Qskydfjrb.Tables[0].Rows[0]["yydh"].ToString();
if (DS_Fwxother.Tables[0].Rows.Count > 0)
{
s = Fwx_other_upload(DS_Fwxother, stryydh);
//if (Fwx_other_UploadDS(DS_Fwxother) == common_file.common_app.get_suc)//添加到远程的Fwx_other_temp表成功
//{
// DataSet ds_Fwx_other_temp = B_Fwx_other.GetList("yydh='" + stryydh + "'");
// if (Add_Fwx_other(ds_Fwx_other_temp, stryydh) == common_file.common_app.get_suc)//添加到Qskyd_fjrb表里
// {
// s = common_file.common_app.get_suc;
// }
//}
}
if (DS_Qskydfjrb.Tables[0].Rows.Count > 0)
{
s = Qskyd_fjrb_upload(DS_Qskydfjrb, stryydh);
//if (Qskyd_fjrb_UploadDS(DS_Qskydfjrb) == common_file.common_app.get_suc)//添加到远程的Qskyd_fjrb_temp表成功
//{
// DataSet ds = B_Qskydfjrb.GetList("yydh='"+stryydh+"'");
// if (Add_Qskyd_fjrb(ds,stryydh) == common_file.common_app.get_suc)//添加到Qskyd_fjrb表里
// {
// s = common_file.common_app.get_suc;
// }
//}
}
return(s);
}
public string Qskyd_fjrb_temp_ADD(DataSet DS_Fwxother, DataSet DS_Qskydfjrb)
{
BLL.Fwx_other_temp B_Fwx_other = new BLL.Fwx_other_temp();
BLL.Qskyd_fjrb_temp B_Qskydfjrb = new BLL.Qskyd_fjrb_temp();
string s = common_file.common_app.get_failure;
string stryydh = DS_Qskydfjrb.Tables[0].Rows[0]["yydh"].ToString();
try
{
if (DS_Fwxother != null && DS_Fwxother.Tables[0].Rows.Count > 0)
{
Fwx_other_upload(DS_Fwxother, stryydh);
}
else
{
string strSql = "delete from Fwx_other where yydh='" + stryydh + "'";
DbHelperSQL.ExecuteSql(strSql);
}
if (DS_Qskydfjrb != null && DS_Qskydfjrb.Tables[0].Rows.Count > 0)
{
Qskyd_fjrb_upload(DS_Qskydfjrb, stryydh);
}
s = common_file.common_app.get_suc;
}
catch (System.Exception ex)
{
LogHelper.WriteLog("上传维修房及房间类型信息时出错" + ex.ToString());
}
return(s);
}
public string Qskyd_fjrb_UploadDS(DataSet DS_Qskydfjrb) //上传Qskyd_fjrb ds添加到远程Qskyd_fjrb_tem临时表
{
//id,yydh,qymc,lsbh,krxm,sktt,yddj,fjrb,fjbh,ddsj,lksj,lzfs,shqh,fjjg,sjfjjg,yh,yhbl,bz,is_top,is_select,shsc,czy,czsj,cznr,sdcz,fjbm
string s = common_file.common_app.get_failure;
BLL.Qskyd_fjrb_temp B_Qskydfjrb = new BLL.Qskyd_fjrb_temp();
Model.Qskyd_fjrb_temp M_Qskydfjrb = new Model.Qskyd_fjrb_temp();
if (DS_Qskydfjrb != null && DS_Qskydfjrb.Tables[0].Rows.Count > 0)
{
string dsqymc = DS_Qskydfjrb.Tables[0].Rows[0]["yydh"].ToString();
DbHelperSQL.ExecuteSql("delete from Qskyd_fjrb_temp where yydh='" + dsqymc + "'");
foreach (DataRow dr in DS_Qskydfjrb.Tables[0].Rows)
{
//string hykh_service = dr["lsbh"].ToString();
M_Qskydfjrb.yydh = dr["yydh"].ToString();
M_Qskydfjrb.qymc = dr["qymc"].ToString();
M_Qskydfjrb.lsbh = dr["lsbh"].ToString();
M_Qskydfjrb.krxm = dr["krxm"].ToString();
M_Qskydfjrb.sktt = dr["sktt"].ToString();
M_Qskydfjrb.yddj = dr["yddj"].ToString();
M_Qskydfjrb.fjrb = dr["fjrb"].ToString();
M_Qskydfjrb.fjbh = dr["fjbh"].ToString();
M_Qskydfjrb.ddsj = Convert.ToDateTime(dr["ddsj"].ToString());
M_Qskydfjrb.lksj = Convert.ToDateTime(dr["lksj"].ToString());
M_Qskydfjrb.lzfs = Convert.ToDecimal(dr["lzfs"].ToString());
M_Qskydfjrb.shqh = dr["shqh"].ToString();
M_Qskydfjrb.fjjg = Convert.ToDecimal(dr["fjjg"].ToString());
M_Qskydfjrb.sjfjjg = Convert.ToDecimal(dr["sjfjjg"].ToString());
M_Qskydfjrb.yh = dr["yh"].ToString();
M_Qskydfjrb.yhbl = Convert.ToDecimal(dr["yhbl"].ToString());
M_Qskydfjrb.bz = dr["bz"].ToString();
M_Qskydfjrb.shsc = true;
M_Qskydfjrb.czy = dr["czy"].ToString();
M_Qskydfjrb.czsj = Convert.ToDateTime(dr["czsj"].ToString());
M_Qskydfjrb.cznr = dr["cznr"].ToString();
M_Qskydfjrb.sdcz = Convert.ToBoolean(dr["sdcz"].ToString());
M_Qskydfjrb.fjbm = dr["fjbm"].ToString();
if (B_Qskydfjrb.Add(M_Qskydfjrb) > 0)
{
s = common_file.common_app.get_suc;
}
}
}
return(s);
}
