public static string Add_Fwx_other(DataSet DS_Fwx_other_temp, string yydh) { string s = common_file.common_app.get_failure; if (DS_Fwx_other_temp != null && DS_Fwx_other_temp.Tables[0].Rows.Count > 0) { Model.Fwx_other M_Fwx_other = new Model.Fwx_other(); BLL.Fwx_other B_Fwx_other = new BLL.Fwx_other(); string strlsbh_ds = ""; //记录总的lsbh以“,”号隔开 foreach (DataRow dr in DS_Fwx_other_temp.Tables[0].Rows) { string strLsbh = dr["lsbh"].ToString(); M_Fwx_other.yydh = dr["yydh"].ToString(); M_Fwx_other.qymc = dr["qymc"].ToString(); M_Fwx_other.lsbh = dr["lsbh"].ToString(); M_Fwx_other.fjrb = dr["fjrb"].ToString(); M_Fwx_other.fjbh = dr["fjbh"].ToString(); M_Fwx_other.ddsj = Convert.ToDateTime(dr["ddsj"].ToString()); M_Fwx_other.lksj = Convert.ToDateTime(dr["lksj"].ToString()); M_Fwx_other.bz = dr["bz"].ToString(); M_Fwx_other.zyzt = dr["zyzt"].ToString(); M_Fwx_other.czsj = Convert.ToDateTime(dr["czsj"].ToString()); M_Fwx_other.cznr = dr["cznr"].ToString(); M_Fwx_other.czy = dr["czy"].ToString(); M_Fwx_other.shsc = true; //如果有相同lsbh就修改,,然后添加。 DataSet ds = B_Fwx_other.GetList("lsbh='" + strLsbh + "'"); if (ds != null && ds.Tables[0].Rows.Count > 0) { int fid = Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString()); M_Fwx_other.id = fid; if (B_Fwx_other.Update(M_Fwx_other)) { s = common_file.common_app.get_suc; } } else { if (B_Fwx_other.Add(M_Fwx_other) > 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 Fwx_other where lsbh not in(" + strlsbh_ds + ") and yydh='" + yydh + "'"; DbHelperSQL.ExecuteSql(strsql); s = common_file.common_app.get_suc; } } return(s); }
/// <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++); }
// id,yydh,qymc,lsbh,fjrb,fjbh,ddsj,lksj,bz,zyzt,czsj,cznr,czy,is_top,is_select,shsc public string Fwx_other_UploadDS(DataSet DS_Fwxother) //άÐÞ·¿ÉÏ´« { DbHelperSQLP Helpsql = new DbHelperSQLP(); string s = common_file.common_app.get_failure; BLL.Fwx_other B_Fwx_other = new BLL.Fwx_other(); Model.Fwx_other M_Fwx_other = new Model.Fwx_other(); if (DS_Fwxother != null && DS_Fwxother.Tables[0].Rows.Count > 0) { string dsqymc = DS_Fwxother.Tables[0].Rows[0]["yydh"].ToString(); DbHelperSQL.ExecuteSql("delete from Fwx_other where yydh='" + dsqymc + "'"); foreach (DataRow dr in DS_Fwxother.Tables[0].Rows) { SqlParameter[] parameters = { new SqlParameter("@yydh", SqlDbType.VarChar, 50), new SqlParameter("@qymc", SqlDbType.VarChar, 50), new SqlParameter("@lsbh", SqlDbType.VarChar, 50), new SqlParameter("@fjrb", SqlDbType.VarChar, 50), new SqlParameter("@fjbh", SqlDbType.VarChar, 50), new SqlParameter("@ddsj", SqlDbType.DateTime), new SqlParameter("@lksj", SqlDbType.DateTime), new SqlParameter("@bz", SqlDbType.VarChar, 50), new SqlParameter("@zyzt", SqlDbType.VarChar, 50), new SqlParameter("@czsj", SqlDbType.DateTime), new SqlParameter("@cznr", SqlDbType.VarChar, 50), new SqlParameter("@czy", SqlDbType.VarChar, 50), new SqlParameter("@is_top", SqlDbType.Bit, 1), new SqlParameter("@is_select", SqlDbType.Bit, 1), new SqlParameter("@shsc", SqlDbType.Bit, 1) }; parameters[0].Value = dr[1]; parameters[1].Value = dr[2]; parameters[2].Value = dr[3]; parameters[3].Value = dr[4]; parameters[4].Value = dr[5]; parameters[5].Value = Convert.ToDateTime(dr[6]); parameters[6].Value = Convert.ToDateTime(dr[7]); parameters[7].Value = dr[8]; parameters[8].Value = dr[9]; parameters[9].Value = Convert.ToDateTime(dr[10]); parameters[10].Value = dr[11]; parameters[11].Value = dr[12]; parameters[12].Value = Convert.ToBoolean(dr[13]); parameters[13].Value = Convert.ToBoolean(dr[14]); parameters[14].Value = true; Helpsql.RunProcedure("Fwx_other_ADD", parameters); s = common_file.common_app.get_suc; } } return(s); }