/// <summary>
/// 门店上传散客房间到中心服务器
/// </summary>
/// <returns></returns>
public static int UpLoad_Qskyd_fjrb()
{
int i = 0;
string s = common_app.get_failure;
Model.Qskyd_fjrb M_Qskyd_fjrb = new Model.Qskyd_fjrb();
BLL.Qskyd_fjrb B_Qskyd_fjrb = new BLL.Qskyd_fjrb();
BLL.Fwx_other B_Fwx_other = new BLL.Fwx_other();
DataSet DS_Qskyd_fjrb = new DataSet();
DataSet DS_Fwx_other = new DataSet();
DS_Qskyd_fjrb = B_Qskyd_fjrb.GetList("1=1");
DS_Fwx_other = B_Fwx_other.GetList("1=1");
if (DS_Qskyd_fjrb != null && DS_Qskyd_fjrb.Tables[0].Rows.Count > 0)
{
object[] args = new object[2];
args[0] = DS_Fwx_other;
args[1] = DS_Qskyd_fjrb;
object result = jdgl_res_head_app.DynamicWebServiceCall.InvokeWebService(url, "Qskyd_fjrb_temp_ADD", args);
if (result.ToString() == common_file.common_app.get_suc)
{
Common_Shsc.Updatshsc(DS_Qskyd_fjrb, "Qskyd_fjrb");
Common_Shsc.Updatshsc(DS_Fwx_other, "Fwx_other");
i += Common_Shsc.GetRowCount(DS_Qskyd_fjrb);
i += Common_Shsc.GetRowCount(DS_Fwx_other);
Common.AddMsg(DS_Qskyd_fjrb, "上传房间类别");
Common.AddMsg(DS_Fwx_other, "上传维修房");
}
}
return(i++);
}
private string GetjzOrgjToZz_helper(string lsbh_old, string lsbh_new, string sk_tt, string Zz_Type, string yydh, string czy, string czy_bc, string czsj, string syzd, string xxzs)//对GetjzOrgjToZz方法的辅助方法
{
//对每个表(Sjzzd,Sjzmx，循环查找，删除Sjzzd,Sjzmx里面的记录,将记录加到
//Sjzzd
string s = common_file.common_app.get_failure;
DataSet ds_temp = new DataSet();
Model.Sjzzd M_Sjzzd = B_sjjzd.GetModelList("id>0 and yydh='" + yydh + "' and lsbh='" + lsbh_old + "'")[0];
krxm_old = M_Sjzzd.krxm;
fjbh_old = M_Sjzzd.fjbh;
//转向散客（
if (Zz_Type == common_zw.zwzz_gz_sk || Zz_Type == common_zw.zwzz_jz_sk)
{
ds_temp = B_Qskyd_fjrb.GetList("id>0 and yydh='" + yydh + "' and lsbh='" + lsbh_new + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
krxm_new = ds_temp.Tables[0].Rows[0]["krxm"].ToString();
fjbh_new = ds_temp.Tables[0].Rows[0]["fjbh"].ToString();
sk_tt_afterZZ = ds_temp.Tables[0].Rows[0]["sktt"].ToString();
}
}
//转向团体（fjbh为空)
if (Zz_Type == common_zw.zwzz_jz_tt || Zz_Type == common_zw.zwzz_gz_tt)
{
ds_temp = B_Qttyd_mainrecord.GetList("id>0 and yydh='" + yydh + "' and lsbh='" + lsbh_new + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
krxm_new = ds_temp.Tables[0].Rows[0]["krxm"].ToString();
fjbh_new = "";
sk_tt_afterZZ = ds_temp.Tables[0].Rows[0]["sktt"].ToString();
}
}
if (GetjzOrgjToZz_helper_InsertToSzwzz_mx(lsbh_old, lsbh_new, krxm_old, krxm_new, fjbh_old, fjbh_new, "Syjcz", Zz_Type, czy, czsj, Zz_Type, yydh) == common_file.common_app.get_suc)
{
if (GetjzOrgjToZz_helper_InsertToSzwzz_mx(lsbh_old, lsbh_new, krxm_old, krxm_new, fjbh_old, fjbh_new, "Szwmx", Zz_Type, czy, czsj, Zz_Type, yydh) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
}
StringBuilder strsql = new StringBuilder();
strsql.Append("delete from Sjzzd");
strsql.Append(" where lsbh='" + lsbh_old + "' and yydh='" + yydh + "'");
B_common.ExecuteSql(strsql.ToString());
strsql = new StringBuilder();
strsql.Append("delete from Sjzmx");
strsql.Append(" where lsbh='" + lsbh_old + "' and yydh='" + yydh + "'");
B_common.ExecuteSql(strsql.ToString());
return(s);
}
private string GetjzOrgzOrZaiZToZz_helper(string lsbh_old, string jzbh_old, string lsbh_new, string sk_tt, string Zz_Type, string yydh, string czy, string czy_bc, string czsj, string syzd, string xxzs, string czy_GUID)//对GetjzOrgjToZz方法的辅助方法
{
//对每个表(Sjzzd,Sjzmx，循环查找，删除Sjzzd,Sjzmx里面的记录,将记录加到
//Sjzzd
string s = common_file.common_app.get_failure;
DataSet ds_temp = new DataSet();
zz_lsbh = common_file.common_ddbh.ddbh("zwzz", "jzdate", "jzcounter", 6);
#region 获取转入的团体或者散客的信息（krxm_new,fjbh_new)
//转向散客
if (Zz_Type == common_zw.zwzz_gz_sk || Zz_Type == common_zw.zwzz_jz_sk || Zz_Type == common_zw.zwzz_sk_sk || Zz_Type == common_zw.zwzz_tt_sk)
{
ds_temp = B_Qskyd_fjrb.GetList("id>0 and yydh='" + yydh + "' and lsbh='" + lsbh_new + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
krxm_new = ds_temp.Tables[0].Rows[0]["krxm"].ToString();
fjbh_new = ds_temp.Tables[0].Rows[0]["fjbh"].ToString();
fjrb_new = ds_temp.Tables[0].Rows[0]["fjrb"].ToString();
sktt_new = ds_temp.Tables[0].Rows[0]["sktt"].ToString();
}
}
//转向团体（fjbh为空)
if (Zz_Type == common_zw.zwzz_jz_tt || Zz_Type == common_zw.zwzz_gz_tt || Zz_Type == common_zw.zwzz_sk_tt || Zz_Type == common_zw.zwzz_tt_tt)
{
ds_temp = B_Qttyd_mainrecord.GetList("id>0 and yydh='" + yydh + "' and lsbh='" + lsbh_new + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
krxm_new = ds_temp.Tables[0].Rows[0]["krxm"].ToString();
fjbh_new = "";
fjrb_new = "";//团体没有房间类别
sktt_new = ds_temp.Tables[0].Rows[0]["sktt"].ToString();
}
}
#endregion
#region 转帐时旧获取旧的信息(krxm_old,fjbh_old)
//挂或者记帐转帐旧的信息的获取
if (Zz_Type == common_zw.zwzz_jz_sk || Zz_Type == common_zw.zwzz_jz_tt || Zz_Type == common_zw.zwzz_gz_sk || Zz_Type == common_zw.zwzz_gz_tt)
{
Model.Sjzzd M_Sjzzd = B_sjjzd.GetModelList("id>0 and yydh='" + yydh + "' and lsbh='" + lsbh_old + "' and jzbh='" + jzbh_old + "'")[0];
krxm_old = M_Sjzzd.krxm;
fjbh_old = M_Sjzzd.fjbh;
sktt_old = M_Sjzzd.sktt;
}
//在住类型的转帐旧的信息的获取
if (Zz_Type == common_zw.zwzz_sk_sk || Zz_Type == common_zw.zwzz_sk_tt || Zz_Type == common_zw.zwzz_tt_sk || Zz_Type == common_zw.zwzz_tt_tt)
{
//散客类型转
if (Zz_Type == common_zw.zwzz_sk_sk || Zz_Type == common_zw.zwzz_sk_tt)
{
ds_temp = new DataSet();
ds_temp = B_common.GetList("select krxm,fjbh from View_Qskzd", " lsbh='" + lsbh_old + "' and yydh='" + yydh + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
krxm_old = ds_temp.Tables[0].Rows[0]["krxm"].ToString();
fjbh_old = ds_temp.Tables[0].Rows[0]["fjbh"].ToString();
}
}
//团体类型转
if (Zz_Type == common_zw.zwzz_tt_sk || Zz_Type == common_zw.zwzz_tt_tt)
{
ds_temp = new DataSet();
ds_temp = B_common.GetList("select krxm from View_Qttzd", " lsbh='" + lsbh_old + "' and yydh='" + yydh + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
krxm_old = ds_temp.Tables[0].Rows[0]["krxm"].ToString();
fjbh_old = "";//团体房号为空
}
}
}
#endregion
#region //挂记帐类型执行的操作
if (Zz_Type == common_zw.zwzz_jz_sk || Zz_Type == common_zw.zwzz_jz_tt || Zz_Type == common_zw.zwzz_gz_sk || Zz_Type == common_zw.zwzz_gz_tt)
{
if (GetjzOrgjToZz_helper_InsertToSzwzz_mx(lsbh_old, jzbh_old, lsbh_new, krxm_old, krxm_new, fjbh_old, fjbh_new, "Syjcz", Zz_Type, czy, czsj, Zz_Type, yydh, zz_lsbh, czy_GUID) == common_file.common_app.get_suc)
{
if (GetjzOrgjToZz_helper_InsertToSzwzz_mx(lsbh_old, jzbh_old, lsbh_new, krxm_old, krxm_new, fjbh_old, fjbh_new, "Szwmx", Zz_Type, czy, czsj, Zz_Type, yydh, zz_lsbh, czy_GUID) == common_file.common_app.get_suc)
{
//jzzd到bak，备份jzmx到bak ，备份押金操作到bak
//删除jzmx及jzzd里面的数据
//更新Ssyxfmx及Ssyxfmx里面的lsbh
//更新转入的Szwzd里面的xfje和fkje
//获取转帐的金额
if (Zz_Type == common_zw.zwzz_jz_sk || Zz_Type == common_zw.zwzz_jz_tt || Zz_Type == common_zw.zwzz_gz_sk || Zz_Type == common_zw.zwzz_gz_tt)
{
ds_temp = B_common.GetList("select * from Sjzzd ", " id>0 and yydh='" + yydh + "' and jzbh='" + jzbh_old + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
xfje_zz = decimal.Parse(ds_temp.Tables[0].Rows[0]["xfje"].ToString());
fkje_zz = decimal.Parse(ds_temp.Tables[0].Rows[0]["fkje"].ToString());
}
}
string Zz_Type_temp = "";//备份时主单及明细的状态
if (Zz_Type == common_zw.zwzz_jz_sk || Zz_Type == common_zw.zwzz_jz_tt)
{
Zz_Type_temp = common_file.common_jzzt.czzt_jzzzz;
}
if (Zz_Type == common_zw.zwzz_gz_sk || Zz_Type == common_zw.zwzz_gz_tt)
{
Zz_Type_temp = common_file.common_jzzt.czzt_gzzzz;
}
strsql = new StringBuilder();//备份jzzd--jzzd_bak
strsql.Append("insert into sjzzd_bak(yydh,qymc,jzbh,jzbh_new,lsbh,is_top,is_select,krxm,sktt,fjbh,xydw,krly,tfsj,czsj,czy,czzt,xyh,jzzt,sdcz,syzd,bz,fp_print,is_visible,fkje,xfje,ddsj,krxm_lz,fjbh_lz)");
strsql.Append("select yydh,qymc,jzbh,'',lsbh,is_top,is_select,krxm,sktt,fjbh,xydw,krly,tfsj,czsj,czy,'" + Zz_Type_temp + "',xyh,jzzt,sdcz,syzd,'" + "帐务由lsbh:" + lsbh_old + "通过:" + Zz_Type + "方式转到lsbh:" + lsbh_new + "',fp_print,is_visible,fkje,xfje,ddsj,krxm_lz,fjbh_lz from sjzzd");
strsql.Append(" where lsbh='" + lsbh_old + "' and jzbh='" + jzbh_old + "' and yydh='" + yydh + "'");
B_common.ExecuteSql(strsql.ToString());
strsql = new StringBuilder();//备份jzmx--jzmx_bak
strsql.Append("insert into sjzmx_bak(yydh,qymc,is_top,is_select,id_app,jzbh,jzbh_new,lsbh,krxm,fjrb,fjbh,sktt,xfrq,xfsj,czy,xfdr,xfrb,xfxm,xfbz,xfzy,jjje,xfje,yh,sjxfje,xfsl,shsc,czy_bc,czzt,czsj,syzd,is_visible,xyh,jzzt,fkfs,mxbh,tfsj)");
strsql.Append("select yydh,qymc,is_top,is_select,id_app,jzbh,'',lsbh,krxm,fjrb,fjbh,sktt,xfrq,xfsj,czy,xfdr,xfrb,xfxm,xfbz,xfzy,jjje,xfje,yh,sjxfje,xfsl,shsc,czy_bc,'" + Zz_Type_temp + "','" + czsj + "',syzd,is_visible,xyh,jzzt,fkfs,mxbh,tfsj from sjzmx");
strsql.Append(" where yydh='" + yydh + "' and jzbh='" + jzbh_old + "'");
B_common.ExecuteSql(strsql.ToString());
//更新收银消费明细里面的临时编号到new
strsql = new StringBuilder();
strsql.Append("update Ssyxfmx set lsbh='" + lsbh_new + "',jzbh='' where id>=0 and jzbh='" + jzbh_old + "' and yydh='" + yydh + "'");
B_common.ExecuteSql(strsql.ToString());
//更新转入的LSBH对应Szwzd的消费和付款金额
strsql = new StringBuilder();
strsql.Append("update Szwzd set xfje=xfje+" + xfje_zz + ",fkje=fkje+" + fkje_zz + " where id>=0 and lsbh='" + lsbh_new + "' and yydh='" + yydh + "'");
B_common.ExecuteSql(strsql.ToString());
strsql = new StringBuilder();
strsql.Append("delete from Sjzzd");
strsql.Append(" where lsbh='" + lsbh_old + "' and jzbh='" + jzbh_old + "' and yydh='" + yydh + "'");
B_common.ExecuteSql(strsql.ToString());
strsql = new StringBuilder();
strsql.Append("delete from Sjzmx");
strsql.Append(" where jzbh='" + jzbh_old + "' and yydh='" + yydh + "'");
B_common.ExecuteSql(strsql.ToString());
s = common_file.common_app.get_suc;
}
}
}
#endregion
#region //在住类型执行的操作
if (Zz_Type == common_zw.zwzz_sk_sk || Zz_Type == common_zw.zwzz_sk_tt || Zz_Type == common_zw.zwzz_tt_sk || Zz_Type == common_zw.zwzz_tt_tt)
{
if (GetjzOrgjToZz_helper_InsertToSzwzz_mx(lsbh_old, jzbh_old, lsbh_new, krxm_old, krxm_new, fjbh_old, fjbh_new, "Szwmx", Zz_Type, czy, czsj, Zz_Type, yydh, zz_lsbh, czy_GUID) == common_file.common_app.get_suc)
{
//在住的转帐(更新两边的Szwzd的消费金额)
//更新转入的LSBH对应Szwzd的消费和付款金额
strsql = new StringBuilder();
strsql.Append("update Szwzd set xfje=xfje+" + xfje_zz + ",fkje=fkje+" + fkje_zz + " where id>=0 and lsbh='" + lsbh_new + "' and yydh='" + yydh + "'");
B_common.ExecuteSql(strsql.ToString());
strsql = new StringBuilder();
strsql.Append("update Szwzd set xfje=xfje-(" + xfje_zz + "),fkje=fkje-(" + fkje_zz + ") where id>=0 and lsbh='" + lsbh_old + "' and yydh='" + yydh + "'");
B_common.ExecuteSql(strsql.ToString());
//更新收银消费明细里面的临时编号到new(注意,只能更新在Szw_zz_fj_temp里面的记录)
strsql = new StringBuilder();
strsql.Append("update Ssyxfmx set lsbh='" + lsbh_new + "',jzbh='' where id>=0 and id_app in (select id_app from Szw_zz_fj_temp where lsbh='" + lsbh_old + "' and yydh='" + yydh + "')");
B_common.ExecuteSql(strsql.ToString());
//最后，删除Szw_zz_fj_temp,以及Szw_temp里面的临时数据
strsql = new StringBuilder();
strsql.Append(" delete from Szw_zz_fj_temp where lsbh='" + lsbh_old + "' and yydh='" + yydh + "'");
B_common.ExecuteSql(strsql.ToString());
strsql = new StringBuilder();
strsql.Append(" delete from Szw_temp where lsbh='" + lsbh_old + "' and yydh='" + yydh + "'");
B_common.ExecuteSql(strsql.ToString());
s = common_file.common_app.get_suc;
}
}
#endregion
if (s == common_file.common_app.get_suc)
{
DataSet ds_0 = B_common.GetList(" select * from Szwzz_mx ", " id>=0 and yydh='" + yydh + "' and xfzy='" + zz_lsbh + "'");
if (ds_0 != null && ds_0.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds_0.Tables[0].Rows.Count; i++)
{
B_common.ExecuteSql(" delete from Szw_union where id>=0 and yydh='" + yydh + "' and union_bh in (select union_bh from Szw_union where id_app='" + ds_0.Tables[0].Rows[i]["id_app"].ToString() + "')");
}
}
}
return(s);
}
//2012.5.11本地传到远程的Qskyd_fjrb_temp然后在添加到Qskyd_fjrb表
//1.如果有相同的lsbh就修改，否者添加。
//2.最后和Qskyd_fjrb_temp这张表对比，如果Qskyd_fjrb not in(lsbh)的条件就删除
//这样做是怕本的删除了远程有可能还有这条记录在
public static string Add_Qskyd_fjrb(DataSet DS_Qskyd_fjrb, string yydh)
{
// 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,jcje
string s = common_file.common_app.get_failure;
if (DS_Qskyd_fjrb != null && DS_Qskyd_fjrb.Tables[0].Rows.Count > 0)
{
Model.Qskyd_fjrb M_Qskyd_fjrb = new Model.Qskyd_fjrb();
BLL.Qskyd_fjrb B_Qskyd_fjrb = new BLL.Qskyd_fjrb();
string strlsbh_ds = ""; //记录总的lsbh以“，”号隔开
foreach (DataRow dr in DS_Qskyd_fjrb.Tables[0].Rows)
{
string strLsbh = dr["lsbh"].ToString();
M_Qskyd_fjrb.lsbh = dr["lsbh"].ToString();
M_Qskyd_fjrb.yydh = dr["yydh"].ToString();
M_Qskyd_fjrb.qymc = dr["qymc"].ToString();
M_Qskyd_fjrb.krxm = dr["krxm"].ToString();
M_Qskyd_fjrb.sktt = dr["sktt"].ToString();
M_Qskyd_fjrb.yddj = dr["yddj"].ToString();
M_Qskyd_fjrb.fjrb = dr["fjrb"].ToString();
M_Qskyd_fjrb.fjbh = dr["fjbh"].ToString();
M_Qskyd_fjrb.ddsj = Convert.ToDateTime(dr["ddsj"].ToString());
M_Qskyd_fjrb.lksj = Convert.ToDateTime(dr["lksj"].ToString());
M_Qskyd_fjrb.lzfs = Convert.ToDecimal(dr["lzfs"].ToString());
M_Qskyd_fjrb.shqh = dr["shqh"].ToString();
M_Qskyd_fjrb.fjjg = Convert.ToDecimal(dr["fjjg"].ToString());
M_Qskyd_fjrb.sjfjjg = Convert.ToDecimal(dr["sjfjjg"].ToString());
M_Qskyd_fjrb.yh = "";
M_Qskyd_fjrb.yhbl = 0;
M_Qskyd_fjrb.bz = "";
M_Qskyd_fjrb.is_top = false;
M_Qskyd_fjrb.is_select = false;
M_Qskyd_fjrb.shsc = true;
M_Qskyd_fjrb.czy = dr["czy"].ToString();
M_Qskyd_fjrb.czsj = Convert.ToDateTime(dr["czsj"].ToString());
M_Qskyd_fjrb.cznr = dr["cznr"].ToString();
//如果有相同lsbh就修改，，然后添加。
DataSet ds = B_Qskyd_fjrb.GetList("lsbh='" + strLsbh + "' and fjrb='" + dr["fjrb"].ToString() + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
int fid = Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString());
M_Qskyd_fjrb.id = fid;
if (B_Qskyd_fjrb.Update(M_Qskyd_fjrb))
{
s = common_file.common_app.get_suc;
}
}
else
{
//添加到Qskyd_fjrb表里
if (B_Qskyd_fjrb.Add(M_Qskyd_fjrb) > 0)
{
s = common_file.common_app.get_suc;
}
}
strlsbh_ds += "'" + strLsbh + "'" + ","; //累加lsbh以“，”号相隔
}
s = common_file.common_app.get_suc;
//相反不相等的话就删除，防止本地删除中央服务器还没有删除lsbh not in
if (strlsbh_ds.Length != 0)
{
strlsbh_ds = strlsbh_ds.Remove(strlsbh_ds.Length - 1, 1);//删除最后一个，号
string strsql = "delete from Qskyd_fjrb where lsbh not in(" + strlsbh_ds + ") and yydh='" + yydh + "'";
DbHelperSQL.Exists(strsql);
s = common_file.common_app.get_suc;
}
}
return(s);
}
//2012.5.11本地传到远程的Qskyd_fjrb_temp然后在添加到Qskyd_fjrb表
//1.如果有相同的lsbh就修改，否者添加。
//2.最后和Qskyd_fjrb_temp这张表对比，如果Qskyd_fjrb not in(lsbh)的条件就删除
//这样做是怕本的删除了远程有可能还有这条记录在
public static string Add_Qskyd_fjrb(DataSet DS_Qskyd_fjrb, string yydh)
{
// 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,jcje
string s = common_file.common_app.get_failure;
if (DS_Qskyd_fjrb != null && DS_Qskyd_fjrb.Tables[0].Rows.Count > 0)
{
string strsql_03 = "delete from Qskyd_fjrb where isok=1 and yydh='" + yydh + "'";
DbHelperSQL.ExecuteSql(strsql_03);
Model.Qskyd_fjrb M_Qskyd_fjrb = new Model.Qskyd_fjrb();
BLL.Qskyd_fjrb B_Qskyd_fjrb = new BLL.Qskyd_fjrb();
foreach (DataRow dr in DS_Qskyd_fjrb.Tables[0].Rows)
{
string strLsbh = dr["lsbh"].ToString();
M_Qskyd_fjrb.lsbh = dr["lsbh"].ToString();
M_Qskyd_fjrb.yydh = dr["yydh"].ToString();
M_Qskyd_fjrb.qymc = dr["qymc"].ToString();
M_Qskyd_fjrb.krxm = dr["krxm"].ToString();
M_Qskyd_fjrb.sktt = dr["sktt"].ToString();
M_Qskyd_fjrb.yddj = dr["yddj"].ToString();
M_Qskyd_fjrb.fjrb = dr["fjrb"].ToString();
M_Qskyd_fjrb.fjbh = dr["fjbh"].ToString();
M_Qskyd_fjrb.ddsj = Convert.ToDateTime(dr["ddsj"].ToString());
M_Qskyd_fjrb.lksj = Convert.ToDateTime(dr["lksj"].ToString());
M_Qskyd_fjrb.lzfs = Convert.ToDecimal(dr["lzfs"].ToString());
M_Qskyd_fjrb.shqh = dr["shqh"].ToString();
M_Qskyd_fjrb.fjjg = Convert.ToDecimal(dr["fjjg"].ToString());
M_Qskyd_fjrb.sjfjjg = Convert.ToDecimal(dr["sjfjjg"].ToString());
M_Qskyd_fjrb.yh = "";
M_Qskyd_fjrb.yhbl = 0;
M_Qskyd_fjrb.bz = "";
M_Qskyd_fjrb.is_top = false;
M_Qskyd_fjrb.is_select = false;
M_Qskyd_fjrb.shsc = true;
M_Qskyd_fjrb.czy = dr["czy"].ToString();
M_Qskyd_fjrb.czsj = Convert.ToDateTime(dr["czsj"].ToString());
M_Qskyd_fjrb.cznr = dr["cznr"].ToString();
M_Qskyd_fjrb.isok = true;
//如果有相同lsbh就修改，，然后添加。
DataSet ds = B_Qskyd_fjrb.GetList("lsbh='" + strLsbh + "' and fjrb='" + dr["fjrb"].ToString() + "' and fjbh='" + dr["fjbh"].ToString() + "' and lzfs='" + dr["lzfs"].ToString() + "' and ddsj='" + dr["ddsj"] + "' and lksj='" + dr["lksj"] + "' and isok=0 ");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
int fid = Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString());
string strsql_01 = "update Qskyd_fjrb set isok=1 where id=" + fid + "";
if (DbHelperSQL.ExecuteSql(strsql_01) > 0)
{
M_Qskyd_fjrb.id = fid;
B_Qskyd_fjrb.Update(M_Qskyd_fjrb);
s = common_file.common_app.get_suc;
}
}
else
{
//添加到Qskyd_fjrb表里
if (B_Qskyd_fjrb.Add(M_Qskyd_fjrb) > 0)
{
s = common_file.common_app.get_suc;
}
}
}
string strsql = "delete from Qskyd_fjrb where isok=0 and yydh='" + yydh + "'";
DbHelperSQL.ExecuteSql(strsql);
string strsql_02 = "update Qskyd_fjrb set isok=0 where yydh='" + yydh + "'";
DbHelperSQL.ExecuteSql(strsql_02);
s = common_file.common_app.get_suc;
}
return(s);
}
