public string Ffjrb_UpLoadDS(DataSet DS, string operate) { string s = common_file.common_app.get_failure; if (DS != null && DS.Tables[0].Rows.Count > 0) { web_Fjrb_delete(DS.Tables[0].Rows[0]["yydh"].ToString(), DS.Tables[0].Rows[0]["qymc"].ToString()); foreach (DataRow dr in DS.Tables[0].Rows) { SqlParameter[] sp = { new SqlParameter("@yydh", SqlDbType.VarChar, 50), new SqlParameter("@qymc", SqlDbType.VarChar, 50), new SqlParameter("@fjrx", SqlDbType.VarChar, 50), new SqlParameter("@xy", SqlDbType.VarChar, 50), new SqlParameter("@fxdj", SqlDbType.Decimal, 9), new SqlParameter("@fxmsj", SqlDbType.Decimal, 9), new SqlParameter("@bz", SqlDbType.VarChar, 250), new SqlParameter("@wlfs", SqlDbType.VarChar, 50), new SqlParameter("@mdblf", SqlDbType.Int, 4) }; sp[0].Value = dr[1]; sp[1].Value = dr[2]; sp[2].Value = dr[4]; sp[3].Value = "网络房价"; sp[4].Value = Convert.ToDecimal(dr[5]); sp[5].Value = Convert.ToDecimal(dr[5]); sp[6].Value = "网络房价"; sp[7].Value = "5"; sp[8].Value = 10; int rows = SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "Web_Fjrb_ADD", sp); if (rows > 0) { s = common_file.common_app.get_suc; } } } #region 初始化ffjzt if (s == common_file.common_app.get_suc) { if (string.Equals(operate, common_app.Inital, StringComparison.OrdinalIgnoreCase)) { s = common_app.get_failure; if (DS.Tables[1].Rows.Count > 0) { DataSet ds0 = new DataSet(); DataTable dt = DS.Tables[1].Copy(); ds0.Tables.Add(dt); Ffjzt.Web_Ffjzt Web_Ffjzt_new = new Web_Ffjzt(); s = Web_Ffjzt_new.Ffjzt_UpLoadDS(ds0); } else { s = common_file.common_app.get_suc; } } } #endregion return(s); }
public string Ffjzt_UpLoadDS(DataSet DS) { string s = common_file.common_app.get_failure; Ffjzt.Web_Ffjzt Web_Ffjzt_new = new Web_Ffjzt(); s = Web_Ffjzt_new.Ffjzt_UpLoadDS(DS); return(s); }