| public static ExecuteNonQuery ( SqlConnection connection, CommandType commandType, string commandText ) : int | ||
| connection | SqlConnection | a valid SqlConnection |
| commandType | CommandType | the CommandType (stored procedure, text, etc.) |
| commandText | string | the stored procedure name or T-SQL command |
| return | int | |
public void Import()
{
var mySqlHelper = new MySqlHelper(MySql);
var sqlHelper = new SqlHelper(SqlServer);
var mysql = string.Format("select * from qdt_user");
var dt = mySqlHelper.ExecuteDataTable(mysql);
var sql = "";
var n = 0;
for (var i = 0; i < dt.Rows.Count; i++)
{
sql += "INSERT INTO qdt_user (id,user_name,user_pwd,sex,create_time,update_time,login_time,login_ip,group_id,is_effect," +
"is_delete,email,email_passed,real_name,idno,idcard_passed,mobile,mobile_passed,pay_pwd,pay_pwd_passed," +
"is_lender,is_borrower,money,lock_money,point,quota,pid) " +
"VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}');\r\n"
.FormatWith(dt.Rows[i]["id"], dt.Rows[i]["user_name"], dt.Rows[i]["user_pwd"].ToString().ToUpper(), dt.Rows[i]["sex"], GetTime(dt.Rows[i]["create_time"]), GetTime(dt.Rows[i]["update_time"]), GetTime(dt.Rows[i]["login_time"]), dt.Rows[i]["login_ip"], dt.Rows[i]["group_id"], dt.Rows[i]["is_effect"],
dt.Rows[i]["is_delete"], dt.Rows[i]["email"], true, dt.Rows[i]["real_name"], dt.Rows[i]["idno"], dt.Rows[i]["idcardpassed"], dt.Rows[i]["mobile"], dt.Rows[i]["mobilepassed"], dt.Rows[i]["pay_pwd"].ToString().ToUpper(), !string.IsNullOrWhiteSpace(dt.Rows[i]["pay_pwd"].ToString()),
!dt.Rows[i]["group_id"].Equals(2), dt.Rows[i]["group_id"].Equals(2), dt.Rows[i]["money"], dt.Rows[i]["lock_money"], dt.Rows[i]["point"], dt.Rows[i]["quota"], dt.Rows[i]["pid"]).Replace("'NULL'", "NULL");
if ((i + 1) % 30 != 0) continue;
n += sqlHelper.ExecuteNonQuery(sql);
sql = "";
}
if (!string.IsNullOrWhiteSpace(sql))
n += sqlHelper.ExecuteNonQuery(sql);
Console.WriteLine("成功导入user表：" + n + "条数据！");
}
public void Import()
{
var mySqlHelper = new MySqlHelper(MySql);
var sqlHelper = new SqlHelper(SqlServer);
var mysql = string.Format("select * from qdt_deal");
var dt = mySqlHelper.ExecuteDataTable(mysql);
var sql = "";
var n = 0;
for (var i = 0; i < dt.Rows.Count; i++)
{
sql += "INSERT INTO qdt_deal (id,name,sub_name,cate_id,user_id,description,is_effect,is_delete,borrow_amount,min_loan_money," +
"repay_time,rate,create_time,update_time,is_recommend,buy_count,load_money,repay_money,start_time,success_time," +
"repay_start_time,last_repay_time,next_repay_time,bad_time,deal_status,enddate,services_fee,is_send_bad_msg,bad_msg,loantype," +
"warrant,titlecolor,is_send_contract,max_loan_money,icon,repay_time_type) " +
"VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}','{32}','{33}','{34}','{35}');\r\n"
.FormatWith(dt.Rows[i]["id"], dt.Rows[i]["name"], dt.Rows[i]["sub_name"], dt.Rows[i]["cate_id"], dt.Rows[i]["user_id"], dt.Rows[i]["description"].ToString().Replace('\'', '\"').Replace("./help/id-", "/Help/Index/").Replace("?", ""), dt.Rows[i]["is_effect"], dt.Rows[i]["is_delete"], dt.Rows[i]["borrow_amount"], dt.Rows[i]["min_loan_money"],
dt.Rows[i]["repay_time"], dt.Rows[i]["rate"], GetTime(dt.Rows[i]["create_time"]), GetTime(dt.Rows[i]["update_time"]), dt.Rows[i]["is_recommend"], dt.Rows[i]["buy_count"], dt.Rows[i]["load_money"], dt.Rows[i]["repay_money"], GetTime(dt.Rows[i]["start_time"]), GetTime(dt.Rows[i]["success_time"]),
GetTime(dt.Rows[i]["repay_start_time"]), GetTime(dt.Rows[i]["last_repay_time"]), GetTime(dt.Rows[i]["next_repay_time"]), GetTime(dt.Rows[i]["bad_time"]), dt.Rows[i]["deal_status"], dt.Rows[i]["enddate"], dt.Rows[i]["services_fee"], dt.Rows[i]["is_send_bad_msg"], dt.Rows[i]["bad_msg"], dt.Rows[i]["loantype"],
dt.Rows[i]["warrant"], dt.Rows[i]["titlecolor"], dt.Rows[i]["is_send_contract"], dt.Rows[i]["max_loan_money"], dt.Rows[i]["icon"], dt.Rows[i]["repay_time_type"]).Replace("'NULL'","NULL");
if ((i + 1) % 10 != 0) continue;
n += sqlHelper.ExecuteNonQuery(sql);
sql = "";
}
if (!string.IsNullOrWhiteSpace(sql))
n += sqlHelper.ExecuteNonQuery(sql);
Console.WriteLine("成功导入deal表：" + n + "条数据！");
}
public void Run()
{
var sqlHelper = new SqlHelper(SqlServer);
var money = sqlHelper.ExecuteScalar<decimal>("select SUM(ac.Money) from qdt_user as us, qdt_user_account as ac where us.UserAccountID=ac.Id and us.group_id='3';");
var lockMoney = sqlHelper.ExecuteScalar<decimal>("select SUM(ac.LockMoney) from qdt_user as us, qdt_user_account as ac where us.UserAccountID=ac.Id and us.group_id='3';");
var chargeMoney =
sqlHelper.ExecuteScalar<decimal>(
"select SUM(od.pay_amount) from qdt_user as us, qdt_charge_order as od where us.id=od.user_id and us.group_id='3' and od.update_time>='{0}' and od.update_time<'{1}';"
.FormatWith(StartTime, EndTime));
var carryMoney =
sqlHelper.ExecuteScalar<decimal>(
"select SUM(ca.Money) from qdt_user as us, qdt_user_carry as ca where us.id=ca.user_id and us.group_id='3' and ca.Status='1' and ca.update_time>='{0}' and ca.update_time<'{1}';"
.FormatWith(StartTime, EndTime));
var carryLock =
sqlHelper.ExecuteScalar<decimal>(
"select SUM(ca.Money) from qdt_user as us, qdt_user_carry as ca where us.id=ca.user_id and us.group_id='3' and ca.Status='0' and ca.Create_Time>='{0}' and ca.Create_Time<'{1}';"
.FormatWith(StartTime, EndTime));
var investLock =
sqlHelper.ExecuteScalar<decimal>(
"select SUM(cr.Money) from qdt_user as us, qdt_credit as cr where us.id=cr.UserID and us.group_id='3' and AssignmentID='0' and (cr.Status='1' or cr.Status='2') and cr.CreateTime>='{0}' and cr.CreateTime<'{1}';"
.FormatWith(StartTime, EndTime));
var repayMoney = sqlHelper.ExecuteScalar<decimal>(
"SELECT SUM(re.RepayMoney) FROM qdt_credit_repayment as re, qdt_credit as cr, qdt_user as us where re.TrueRepayTime>='{0}' AND re.TrueRepayTime<'{1}' AND re.CreditId=cr.Id AND cr.UserID=us.id AND us.group_id='3';"
.FormatWith(StartTime, EndTime));
var insertSql =
"insert into qdt_user_money (money,chargemoney,carrymoney,lockmoney,carrylock,investlock,repaymoney) values ('{0}','{1}','{2}','{3}','{4}','{5}',{6});"
.FormatWith(money, chargeMoney, carryMoney, lockMoney, carryLock, investLock,repayMoney);
sqlHelper.ExecuteNonQuery(insertSql);
}
public int DeleteDownClass(DownClassInfo downClass)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@catID", downClass.ID);
return objSqlHelper.ExecuteNonQuery("je_DC_DeleteDownClass", objParams);
}
public static void setActiveStatus(string userLogin, bool isActive)
{
var sql = new SqlHelper("update table_user set status = {0} where login_name = {1}");
sql.Parameters.Add("isActive", isActive ? 1 : 0);
sql.Parameters.Add("login", userLogin);
sql.ExecuteNonQuery();
}
public static void setAllowProxy(string userLogin, bool canProxy)
{
var sql = new SqlHelper("update table_employee set allow_proxy = {0} where objid = (select objid from table_user where login_name = {1})");
sql.Parameters.Add("canProxy", canProxy ? 1 : 0);
sql.Parameters.Add("login", userLogin);
sql.ExecuteNonQuery();
}
public void InsertDownClass(DownClassInfo downClass)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@catName", downClass.ClassName);
objSqlHelper.ExecuteNonQuery("je_DC_InsertDownClass", objParams);
}
public int DeleteTitleCss(int titleCssID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@cssID", titleCssID);
return objSqlHelper.ExecuteNonQuery("je_Tc_DeleteTitleCss", objParams);
}
public int DeleteHelp(int helpID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@helpID", helpID);
return objSqlHelper.ExecuteNonQuery("je_Help_DeleteHelp", objParams);
}
public int DeleteCatena(int catenaID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@catenaID", catenaID);
return objSqlHelper.ExecuteNonQuery("je_Ct_DeleteCatena", objParams);
}
public int DeleteFavBookByID(int bookID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@bookID", bookID);
return objSqlHelper.ExecuteNonQuery("je_FBook_DeleteFavBooksByID", objParams);
}
public int DeleteGuestBookByID(int gbID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@gbID", gbID);
return objSqlHelper.ExecuteNonQuery("je_Gb_DeleteGuestBookByID", objParams);
}
public int DeleteSend(int SendID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@sendID", SendID);
return objSqlHelper.ExecuteNonQuery("je_Send_DeleteSend", objParams);
}
public static void createImpersonationFor(string impersonatingUserLogin, string userLoginBeingImpersonated)
{
var sql = new SqlHelper("update table_user set user2proxy_user = (select objid from table_user where login_name = {0}) where login_name = {1}");
sql.Parameters.Add("login", userLoginBeingImpersonated);
sql.Parameters.Add("proxylogin", impersonatingUserLogin);
sql.ExecuteNonQuery();
}
public int UpdateDownClass(DownClassInfo downClass)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[2];
objParams[0] = new SqlParameter("@catName", downClass.ClassName);
objParams[1] = new SqlParameter("@catID", downClass.ID);
return objSqlHelper.ExecuteNonQuery("je_DC_UpdateDownClass", objParams);
}
public void InsertFavBook(int bookID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[2];
objParams[0] = new SqlParameter("@bookID", bookID);
objParams[1] = new SqlParameter("@userName", GetUserName());
objSqlHelper.ExecuteNonQuery("je_FBook_InsertFavBooks", objParams);
}
public void InsertHelpClass(HelpClassInfo HelpClass)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[2];
objParams[0] = new SqlParameter("@ClassName", HelpClass.ClassName);
objParams[1] = new SqlParameter("@IsVisible", HelpClass.IsVisible);
objSqlHelper.ExecuteNonQuery("je_HC_InsertHelpClass", objParams);
}
public void InsertPayment(PaymentInfo payment)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[2];
objParams[0] = new SqlParameter("@UserName", payment.UserName);
objParams[1] = new SqlParameter("@Dec", payment.Dec);
objSqlHelper.ExecuteNonQuery("je_Pay_InsertPayment", objParams);
}
public void InsertSend(SendInfo send)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[3];
objParams[0] = new SqlParameter("@Name", send.Name);
objParams[1] = new SqlParameter("@Price", send.Price);
objParams[2] = new SqlParameter("@Dec", StringHelper.convertStr(send.Dec));
objSqlHelper.ExecuteNonQuery("je_Send_InsertSend", objParams);
}
public void InsertHelp(HelpInfo help)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[3];
objParams[0] = new SqlParameter("@ClassID", help.ClassID);
objParams[1] = new SqlParameter("@HelpTitle", help.HelpTitle);
objParams[2] = new SqlParameter("@HelpContent", help.HelpContent);
objSqlHelper.ExecuteNonQuery("je_Help_InsertHelp", objParams);
}
public void InsertCatena(BookCatenaInfo catena)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[3];
objParams[0] = new SqlParameter("@catenaName", StringHelper.convertStr(catena.CatenaName));
objParams[1] = new SqlParameter("@catenaDec", StringHelper.convertStr(catena.CatenaDec));
objParams[2] = new SqlParameter("@addDate", DateTime.Now);
objSqlHelper.ExecuteNonQuery("je_Ct_InsertCatena", objParams);
}
public int UpdateHelpClass(HelpClassInfo HelpClass)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[3];
objParams[0] = new SqlParameter("@ClassName", HelpClass.ClassName);
objParams[1] = new SqlParameter("@ClassID", HelpClass.ClassID);
objParams[2] = new SqlParameter("@IsVisible", HelpClass.IsVisible);
return objSqlHelper.ExecuteNonQuery("je_HC_UpdateHelpClass", objParams);
}
public void InsertPublish(PublishInfo publish)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[3];
objParams[0] = new SqlParameter("@publishName", StringHelper.convertStr(publish.PublishName));
objParams[1] = new SqlParameter("@publishDec", StringHelper.convertStr(publish.PublishDec));
objParams[2] = new SqlParameter("@IsMain", publish.IsMain);
objSqlHelper.ExecuteNonQuery("je_Pb_InsertPublish", objParams);
}
public void InsertCategory(CategoryInfo category)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[3];
objParams[0] = new SqlParameter("@categoryName", category.CategoryName);
objParams[1] = new SqlParameter("@parentID", category.ParentID);
objParams[2] = new SqlParameter("@IsMain", category.IsMain);
objSqlHelper.ExecuteNonQuery("je_Cat_InsertCategory", objParams);
}
public void InsertTitleCss(TitleCssInfo titleCss)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[3];
objParams[0] = new SqlParameter("@CssName", StringHelper.convertStr(titleCss.TitleCssName));
objParams[1] = new SqlParameter("@CssDec", StringHelper.convertStr(titleCss.TitleCssDec));
objParams[2] = new SqlParameter("@addDate", DateTime.Now);
objSqlHelper.ExecuteNonQuery("je_Tc_InsertTitleCss", objParams);
}
public int UpdateHelp(HelpInfo help)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[4];
objParams[0] = new SqlParameter("@ClassID", help.ClassID);
objParams[1] = new SqlParameter("@HelpTitle", help.HelpTitle);
objParams[2] = new SqlParameter("@HelpContent", help.HelpContent);
objParams[3] = new SqlParameter("@HelpID", help.HelpID);
return objSqlHelper.ExecuteNonQuery("je_Help_UpdateHelp", objParams);
}
public int UpdateSiteDynamic(SiteDynamicInfo siteDynamic)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[4];
objParams[0] = new SqlParameter("@dynamicID", siteDynamic.DynamicID);
objParams[1] = new SqlParameter("@dynamicTitle", siteDynamic.DynamicTitle);
objParams[2] = new SqlParameter("@titleCss", siteDynamic.DynamicCss);
objParams[3] = new SqlParameter("@dynamicContent", siteDynamic.DynamicContent);
return objSqlHelper.ExecuteNonQuery("je_Dy_UpdateSiteDynamic", objParams);
}
public int UpdateTitleCss(TitleCssInfo titleCss)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[4];
objParams[0] = new SqlParameter("@cssName", StringHelper.convertStr(titleCss.TitleCssName));
objParams[1] = new SqlParameter("@cssDec", StringHelper.convertStr(titleCss.TitleCssDec));
objParams[2] = new SqlParameter("@addDate", DateTime.Now);
objParams[3] = new SqlParameter("@cssID", titleCss.TitleCssID);
return objSqlHelper.ExecuteNonQuery("je_Tc_UpdateTitleCss", objParams);
}
public int UpdateSend(SendInfo send)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[4];
objParams[0] = new SqlParameter("@Name", send.Name);
objParams[1] = new SqlParameter("@Price", send.Price);
objParams[2] = new SqlParameter("@Dec", StringHelper.convertStr(send.Dec));
objParams[3] = new SqlParameter("@sendID", send.SendID);
return objSqlHelper.ExecuteNonQuery("je_Send_UpdateSend", objParams);
}
public void InsertSiteDynamic(SiteDynamicInfo siteDynamic)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[4];
objParams[0] = new SqlParameter("@dynamicTitle", siteDynamic.DynamicTitle);
objParams[1] = new SqlParameter("@titleCss", siteDynamic.DynamicCss);
objParams[2] = new SqlParameter("@dynamicContent", siteDynamic.DynamicContent);
objParams[3] = new SqlParameter("@addDate", DateTime.Now);
objSqlHelper.ExecuteNonQuery("je_Dy_InsertSiteDynamic", objParams);
}
/// <summary>
/// Optimized method for bulk deletion of properties´on a Content object.
/// </summary>
protected void deleteAllProperties()
{
SqlHelper.ExecuteNonQuery("Delete from cmsPropertyData where contentNodeId = @nodeId", SqlHelper.CreateParameter("@nodeId", this.Id));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tEnvFillSeaItem">对象</param>
/// <returns>是否成功</returns>
public bool Create(TEnvFillSeaItemVo tEnvFillSeaItem)
{
string strSQL = SqlHelper.BuildInsertExpress(tEnvFillSeaItem, TEnvFillSeaItemVo.T_ENV_FILL_SEA_ITEM_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//cmd.CommandText = "SELECT [usrMobileNumber],[CandidateRole],[CandidateRoleName],[CandidateDistrictID],[LocalBodyType],[LocalBodyName],[WardNo],[LocalBodyID],[AssemblyID] FROM [TrueVoterDB].[dbo].[tblNewDataCandi_Reg] WHERE [usrMobileNumber]='" + mob + "' AND [CandidateRole] IN (1,2)";
//cmd.CommandType = CommandType.Text;
//cmd.Connection = contrue;
//da.SelectCommand = cmd;
//ds.Clear();
//da.Fill(ds);
SqlParameter[] par = new SqlParameter[5];
par[0] = new SqlParameter("@p1", "4");
par[1] = new SqlParameter("@p2", mob);
par[2] = new SqlParameter("@p3", "0");
par[3] = new SqlParameter("@p4", "0");
ds.Clear();
ds = SqlHelper.ExecuteDataset(contrue, CommandType.StoredProcedure, "uspGetCandidateData", par);
string ipAdd = GetIPAddress();
if (Convert.ToString(ds.Tables[0].Rows[0]["CandidateRole"]) == "3")
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('You registerd as Representative you can not fill Daily Expense')", true);
}
else
{
if (ddlExpenseHead.SelectedItem.Text == "--Select--" || ddlExpenseHead.SelectedValue == "0")
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Select Expense Head')", true);
}
else if (ddlSubExpenseHead.SelectedItem.Text == "--Select--" || ddlSubExpenseHead.SelectedValue == "")
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Select Sub Expense Head')", true);
}
else if (txtDate.Text == "")
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Select Expense Date')", true);
}
else if (txtArea.Text == "")
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Enter Area/Size/Quantity')", true);
}
else if (txtYourRate.Text == "")
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Enter Your Rate')", true);
}
else if (txtAmount.Text == "")
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Enter Amount')", true);
}
else
{
string deviation = CalDaviation();
//string query = "INSERT INTO [TrueVoterDB].[dbo].[tblDailyExpenses] ([Date],[ExpenseType],[SubExpenseType],[Qty_Size_Area],[Rate],[TotalExpense]," +
// "[PaymentMode],[ChequeNo],[PaidAmount],[InvoiceNo],[FirmName],[FirmOwnerMobNo],[InsertDate],[InsertBy],[Unit],[PaymentType]," +
// "[StandardRate],[BalancePayment],[SourceOfExpense],[PartyName],[PartyNo],[CandidateRole],[CandidateRoleName],[CandidateDistrict],[LocalBodyType]," +
// "[LocalBodyNameID],[WardNo],[ReffrenceMobile],[IsApproved],[EntryFrom],[IsActive],[IMEINumber],[Deviation]) "
// + "VALUES ('" + txtDate.Text + "','" + Convert.ToString(ddlExpenseHead.SelectedValue) + "','" + Convert.ToString(ddlSubExpenseHead.SelectedValue) + "','" + txtArea.Text + "'" +
// ",'" + txtYourRate.Text + "','" + txtTotal.Text + "','" + rbPaymentMode.SelectedItem.Text + "','" + txtChequeNo.Text + "','" + txtAmount.Text + "','" + txtBillNo.Text + "'" +
// ",'" + txtVenderName.Text + "','" + txtVenderMobNo.Text + "','" + System.DateTime.Now.ToString("yyyy-MM-dd") + "','" + Convert.ToString(ds.Tables[0].Rows[0]["usrMobileNumber"]) + "'" +
// ",'" + lblUnit.Text + "','" + rbtnPaymentType.SelectedItem.Text + "','" + lblStandardRate.Text + "','" + txtBalpayment.Text + "','" + rbtnSourceExpense.SelectedItem.Text + "'," +
// "'" + txtPartyotherName.Text + "','" + txtPartyotherMobNo.Text + "','" + Convert.ToString(ds.Tables[0].Rows[0]["CandidateRole"]) + "','" + Convert.ToString(ds.Tables[0].Rows[0]["CandidateRoleName"]) + "'," +
// "'" + Convert.ToString(ds.Tables[0].Rows[0]["CandidateDistrictID"]) + "','" + Convert.ToString(ds.Tables[0].Rows[0]["LocalBodyType"]) + "','" + Convert.ToString(ds.Tables[0].Rows[0]["LocalBodyID"]) + "'," +
// "'" + Convert.ToString(ds.Tables[0].Rows[0]["WardNo"]) + "','" + Convert.ToString(ds.Tables[0].Rows[0]["usrMobileNumber"]) + "','1','2','1','" + ipAdd + "','" + deviation + "')";
//cmd.CommandText = query;
//cmd.CommandType = CommandType.Text;
//cmd.Connection = contrue;
//contrue.Open();
//int i = cmd.ExecuteNonQuery();
//contrue.Close();
SqlParameter[] par1 = new SqlParameter[36];
par1[0] = new SqlParameter("@p1", txtDate.Text);
par1[1] = new SqlParameter("@p2", Convert.ToString(ddlExpenseHead.SelectedValue));
par1[2] = new SqlParameter("@p3", Convert.ToString(ddlSubExpenseHead.SelectedValue));
par1[3] = new SqlParameter("@p4", txtArea.Text);
par1[4] = new SqlParameter("@p5", txtYourRate.Text);
par1[5] = new SqlParameter("@p6", txtTotal.Text);
par1[6] = new SqlParameter("@p7", rbPaymentMode.SelectedItem.Text);
par1[7] = new SqlParameter("@p8", txtChequeNo.Text);
par1[8] = new SqlParameter("@p9", txtAmount.Text);
par1[9] = new SqlParameter("@p10", txtBillNo.Text);
par1[10] = new SqlParameter("@p11", txtVenderName.Text);
par1[11] = new SqlParameter("@p12", txtVenderMobNo.Text);
par1[12] = new SqlParameter("@p13", System.DateTime.Now.ToString("yyyy-MM-dd"));
par1[13] = new SqlParameter("@p14", Convert.ToString(ds.Tables[0].Rows[0]["usrMobileNumber"]));
par1[14] = new SqlParameter("@p15", lblUnit.Text);
par1[15] = new SqlParameter("@p16", rbtnPaymentType.SelectedItem.Text);
par1[16] = new SqlParameter("@p17", lblStandardRate.Text);
par1[17] = new SqlParameter("@p18", txtBalpayment.Text);
par1[18] = new SqlParameter("@p19", rbtnSourceExpense.SelectedItem.Text);
par1[19] = new SqlParameter("@p20", txtPartyotherName.Text);
par1[20] = new SqlParameter("@p21", txtPartyotherMobNo.Text);
par1[21] = new SqlParameter("@p22", Convert.ToString(ds.Tables[0].Rows[0]["CandidateRole"]));
par1[22] = new SqlParameter("@p23", Convert.ToString(ds.Tables[0].Rows[0]["CandidateRoleName"]));
par1[23] = new SqlParameter("@p24", Convert.ToString(ds.Tables[0].Rows[0]["CandidateDistrictID"]));
par1[24] = new SqlParameter("@p25", Convert.ToString(ds.Tables[0].Rows[0]["LocalBodyType"]));
par1[25] = new SqlParameter("@p26", Convert.ToString(ds.Tables[0].Rows[0]["LocalBodyID"]));
par1[26] = new SqlParameter("@p27", Convert.ToString(ds.Tables[0].Rows[0]["WardNo"]));
par1[27] = new SqlParameter("@p28", Convert.ToString(ds.Tables[0].Rows[0]["usrMobileNumber"]));
par1[28] = new SqlParameter("@p29", "1");
par1[29] = new SqlParameter("@p30", "2");
par1[30] = new SqlParameter("@p31", "1");
par1[31] = new SqlParameter("@p32", ipAdd);
par1[32] = new SqlParameter("@p33", deviation);
par1[34] = new SqlParameter("@p35", "0");
par1[33] = new SqlParameter("@p34", SqlDbType.Int);
par1[33].Direction = ParameterDirection.InputOutput;
SqlHelper.ExecuteNonQuery(contrue, CommandType.StoredProcedure, "uspInsertDailyExpenseWeb", par1);
string k = par1[33].Value.ToString();
BindGridView();
if (k == "101")
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Record Inserted Successfully...!!!')", true);
clear();
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Record Inserted Failed...!!!')", true);
}
}
}
}
//插入
protected void Button2_Click1(object sender, EventArgs e)
{
string sN = StaffNo.Text;
string sNa = StaffName.Text;
string Ti = Title.Text;
if (sN != "" && sNa != "" && Ti != "")
{
string SQL_Insert = "INSERT INTO Crew_Info"
+ " (Staff_No,Staff_Name,Title,Rcd_Status,Rcd_By)"
+ " VALUES(@sN,@sNa,@Ti,@RS,@RB)";
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@sN", SqlDbType.VarChar, 10),
new SqlParameter("@sNa", SqlDbType.VarChar, 100),
new SqlParameter("@Ti", SqlDbType.VarChar, 50),
new SqlParameter("@RS", SqlDbType.VarChar, 10),
new SqlParameter("@RB", SqlDbType.VarChar, 50)
};
parm[0].Value = sN;
parm[1].Value = sNa;
parm[2].Value = Ti;
parm[3].Value = "NEW";
parm[4].Value = Session["User_ID"].ToString();
try
{
using (SqlConnection conn = new SqlConnection(SqlHelper.Conn))
{
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_Insert, parm);
}
Response.Write("<script>alert('The operation was successful')</script>");
//LOG
string SQL_Log = "INSERT INTO Crew_Check_Log"
+ " (Staff_No,Details_Origin,Details_After_Action,Actions,Rcd_By)"
+ " VALUES(@sN,@DO,@DA,@AC,@RB)";
SqlParameter[] parmlog = new SqlParameter[] {
new SqlParameter("@sN", SqlDbType.VarChar, 10),
new SqlParameter("@DO", SqlDbType.VarChar, 200),
new SqlParameter("@DA", SqlDbType.VarChar, 200),
new SqlParameter("@AC", SqlDbType.VarChar, 50),
new SqlParameter("@RB", SqlDbType.VarChar, 50)
};
parmlog[0].Value = sN;
parmlog[1].Value = "";
parmlog[2].Value = sN + "/" + sNa + "/" + Ti;
parmlog[3].Value = "CREATE";
parmlog[4].Value = Session["User_ID"].ToString();
using (SqlConnection conn = new SqlConnection(SqlHelper.Conn))
{
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_Log, parmlog);
}
//Response.Redirect("Home.aspx");
Response.Write("<script language='javascript'>window.location='Home.aspx'</script>");
}
catch
{
Response.Write("<script>alert('Record already exists')</script>");
}
}
else
{
Response.Write("<script>alert('Please insert the information')</script>");
}
}
public static void ExecProc(string conn, string proName, params SqlParameter[] commandParameters)
{
SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, proName, commandParameters);
}
public static bool DeleteMDBeautyApplyConfig(int id)
{
const string sql = @"DELETE FROM Tuhu_Groupon.dbo.ShopBeautyAcitivityApply WHERE Id=@Id";
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, new SqlParameter("@Id", id)) > 0);
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(string Id)
{
string strSQL = String.Format("delete from T_BASE_EVALUATION_CON_ITEM where ID='{0}'", Id);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tBaseEvaluationConItem">对象</param>
/// <returns>是否成功</returns>
public bool Create(TBaseEvaluationConItemVo tBaseEvaluationConItem)
{
string strSQL = SqlHelper.BuildInsertExpress(tBaseEvaluationConItem, TBaseEvaluationConItemVo.T_BASE_EVALUATION_CON_ITEM_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
public void DeleteAll()
{
string strSql = "TRUNCATE TABLE " + Config.FilterTablePrefix + "BADWORDS ";
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, null);
}
public void DeleteGroup(int _groupid)
{
arParams = new SqlParameter[1];
arParams[0] = new SqlParameter("@groupid", _groupid);
SqlHelper.ExecuteNonQuery(dsn, CommandType.StoredProcedure, "pr_deleteRoleUsers", arParams);
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tSysUserProxy">对象</param>
/// <returns>是否成功</returns>
public bool Create(TSysUserProxyVo tSysUserProxy)
{
string strSQL = SqlHelper.BuildInsertExpress(tSysUserProxy, TSysUserProxyVo.T_SYS_USER_PROXY_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
public int DeleteAttachment()
{
return(SqlHelper.ExecuteNonQuery(Con, CommandType.Text, @"Delete from [ttcisg132200]
WHERE t_dcid= '" + DocumentId + @"'"));
}
public int InsertByOutput(StockLocationInfo model)
{
StringBuilder sb = new StringBuilder(300);
sb.Append(@"insert into StockLocation (Id,UserId,ZoneId,Code,Named,Width,Wide,High,Volume,Cubage,Row,Layer,Col,Passway,Xc,Yc,Zc,Orientation,StockLocationType,StackLimit,GroundTrayQty,StockLocationDeal,CarryWeight,UseStatus,Remark,LastUpdatedDate)
values
(@Id,@UserId,@ZoneId,@Code,@Named,@Width,@Wide,@High,@Volume,@Cubage,@Row,@Layer,@Col,@Passway,@Xc,@Yc,@Zc,@Orientation,@StockLocationType,@StackLimit,@GroundTrayQty,@StockLocationDeal,@CarryWeight,@UseStatus,@Remark,@LastUpdatedDate)
");
SqlParameter[] parms = {
new SqlParameter("@Id",SqlDbType.UniqueIdentifier),
new SqlParameter("@UserId",SqlDbType.UniqueIdentifier),
new SqlParameter("@ZoneId",SqlDbType.UniqueIdentifier),
new SqlParameter("@Code",SqlDbType.VarChar,30),
new SqlParameter("@Named",SqlDbType.NVarChar,50),
new SqlParameter("@Width",SqlDbType.Float),
new SqlParameter("@Wide",SqlDbType.Float),
new SqlParameter("@High",SqlDbType.Float),
new SqlParameter("@Volume",SqlDbType.Float),
new SqlParameter("@Cubage",SqlDbType.Float),
new SqlParameter("@Row",SqlDbType.Float),
new SqlParameter("@Layer",SqlDbType.Float),
new SqlParameter("@Col",SqlDbType.Float),
new SqlParameter("@Passway",SqlDbType.Float),
new SqlParameter("@Xc",SqlDbType.Float),
new SqlParameter("@Yc",SqlDbType.Float),
new SqlParameter("@Zc",SqlDbType.Float),
new SqlParameter("@Orientation",SqlDbType.Float),
new SqlParameter("@StockLocationType",SqlDbType.NVarChar,20),
new SqlParameter("@StackLimit",SqlDbType.Float),
new SqlParameter("@GroundTrayQty",SqlDbType.Float),
new SqlParameter("@StockLocationDeal",SqlDbType.NVarChar,20),
new SqlParameter("@CarryWeight",SqlDbType.Float),
new SqlParameter("@UseStatus",SqlDbType.NVarChar,20),
new SqlParameter("@Remark",SqlDbType.NVarChar,100),
new SqlParameter("@LastUpdatedDate",SqlDbType.DateTime)
};
parms[0].Value = model.Id;
parms[1].Value = model.UserId;
parms[2].Value = model.ZoneId;
parms[3].Value = model.Code;
parms[4].Value = model.Named;
parms[5].Value = model.Width;
parms[6].Value = model.Wide;
parms[7].Value = model.High;
parms[8].Value = model.Volume;
parms[9].Value = model.Cubage;
parms[10].Value = model.Row;
parms[11].Value = model.Layer;
parms[12].Value = model.Col;
parms[13].Value = model.Passway;
parms[14].Value = model.Xc;
parms[15].Value = model.Yc;
parms[16].Value = model.Zc;
parms[17].Value = model.Orientation;
parms[18].Value = model.StockLocationType;
parms[19].Value = model.StackLimit;
parms[20].Value = model.GroundTrayQty;
parms[21].Value = model.StockLocationDeal;
parms[22].Value = model.CarryWeight;
parms[23].Value = model.UseStatus;
parms[24].Value = model.Remark;
parms[25].Value = model.LastUpdatedDate;
return SqlHelper.ExecuteNonQuery(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), parms);
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(string Id)
{
string strSQL = String.Format("delete from T_ENV_FILL_OFFSHORE_ITEM where ID='{0}'", Id);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 更新银行美容配置
/// </summary>
/// <param name="config"></param>
/// <returns></returns>
public static bool UpdateBankMRActivityConfig(SqlConnection conn, BankMRActivityConfig config)
{
var sql = @"UPDATE Tuhu_groupon..BankMRActivityConfig
SET BankId = @BankId ,
ServiceId = @ServiceId ,
ServiceCount = @ServiceCount ,
ServiceName = @ServiceName ,
UserSettlementPrice = @UserSettlementPrice ,
BankSettlementPrice = @BankSettlementPrice ,
ValidDays = @ValidDays ,
BannerImageUrl = @BannerImageUrl ,
RuleDescription = @RuleDescription ,
VerifyType = @VerifyType ,
ActivityName = @ActivityName ,
CooperateId = @CooperateId ,
StartTime = @StartTime ,
EndTime = @EndTime ,
RoundCycleType = @RoundCycleType ,
ButtonColor = @ButtonColor ,
SettleMentMethod = @SettleMentMethod ,
Description = @Description ,
IsActive = @IsActive ,
CustomerType = @CustomerType ,
Card2Length = @Card2Length ,
CodeTypeConfigId=@CodeTypeConfigId ,
MarketPrice=@MarketPrice,
LogoUrl=@LogoUrl,
ActivityLimitDescribe=@ActivityLimitDescribe,
ActivityTimeDescribe=@ActivityTimeDescribe,
BuyTips=@BuyTips ,
RoundStartTime=@RoundStartTime
WHERE ActivityId = @ActivityId";
var sqlParameters = new SqlParameter[]
{
new SqlParameter("@CodeTypeConfigId", config.CodeTypeConfigId),
new SqlParameter("@ActivityId", config.ActivityId),
new SqlParameter("@BankId", config.BankId),
new SqlParameter("@ServiceId", config.ServiceId),
new SqlParameter("@ServiceCount", config.ServiceCount),
new SqlParameter("@ServiceName", config.ServiceName),
new SqlParameter("@UserSettlementPrice", config.UserSettlementPrice),
new SqlParameter("@BankSettlementPrice", config.BankSettlementPrice),
new SqlParameter("@ValidDays", config.ValidDays),
new SqlParameter("@BannerImageUrl", config.BannerImageUrl),
new SqlParameter("@RuleDescription", config.RuleDescription),
new SqlParameter("@VerifyType", config.VerifyType),
new SqlParameter("@ActivityName", config.ActivityName),
new SqlParameter("@CooperateId", config.CooperateId),
new SqlParameter("@StartTime", config.StartTime),
new SqlParameter("@EndTime", config.EndTime),
new SqlParameter("@RoundCycleType", config.RoundCycleType),
new SqlParameter("@ButtonColor", config.ButtonColor),
new SqlParameter("@SettleMentMethod", config.SettleMentMethod),
new SqlParameter("@Description", config.Description),
new SqlParameter("@IsActive", config.IsActive),
new SqlParameter("@CustomerType", config.CustomerType),
new SqlParameter("@Card2Length", config.Card2Length),
new SqlParameter("@MarketPrice", config.MarketPrice),
new SqlParameter("@LogoUrl", config.LogoUrl),
new SqlParameter("@ActivityLimitDescribe", config.ActivityLimitDescribe),
new SqlParameter("@ActivityTimeDescribe", config.ActivityTimeDescribe),
new SqlParameter("@BuyTips", config.BuyTips),
new SqlParameter("@RoundStartTime", config.RoundStartTime),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameters) > 0);
}
public bool delete(int taskId)
{
return(SqlHelper.ExecuteNonQuery("delete from TakeMedicineTask where Id=@id", new MySqlParameter[] {
new MySqlParameter("@id", taskId)
}) > 0);
}
public static void ExecText(string conn, string text)
{
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, text);
}
public int UpdatePurpose()
{
return(SqlHelper.ExecuteNonQuery(Con, CommandType.Text, @"UPDATE [ttcisg129200]
SET [t_desc] = '" + PurposeDesc + @"'
WHERE t_prcd= '" + PurposeCode + @"'"));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(BLG_CommentMod model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BLG_Comment set ");
strSql.Append("ArticleSysNo=@ArticleSysNo,");
strSql.Append("Title=@Title,");
strSql.Append("Context=@Context,");
strSql.Append("CustomerSysNo=@CustomerSysNo,");
strSql.Append("Love=@Love,");
strSql.Append("Hate=@Hate,");
strSql.Append("DR=@DR,");
strSql.Append("TS=@TS");
strSql.Append(" where SysNo=@SysNo ");
SqlCommand cmd = new SqlCommand(strSql.ToString());
SqlParameter[] parameters =
{
new SqlParameter("@SysNo", SqlDbType.Int, 4),
new SqlParameter("@ArticleSysNo", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.NVarChar, 600),
new SqlParameter("@Context", SqlDbType.NVarChar, 2000),
new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4),
new SqlParameter("@Love", SqlDbType.Int, 4),
new SqlParameter("@Hate", SqlDbType.Int, 4),
new SqlParameter("@DR", SqlDbType.TinyInt, 1),
new SqlParameter("@TS", SqlDbType.DateTime)
};
if (model.SysNo != AppConst.IntNull)
{
parameters[0].Value = model.SysNo;
}
else
{
parameters[0].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[0]);
if (model.ArticleSysNo != AppConst.IntNull)
{
parameters[1].Value = model.ArticleSysNo;
}
else
{
parameters[1].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[1]);
if (model.Title != AppConst.StringNull)
{
parameters[2].Value = model.Title;
}
else
{
parameters[2].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[2]);
if (model.Context != AppConst.StringNull)
{
parameters[3].Value = model.Context;
}
else
{
parameters[3].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[3]);
if (model.CustomerSysNo != AppConst.IntNull)
{
parameters[4].Value = model.CustomerSysNo;
}
else
{
parameters[4].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[4]);
if (model.Love != AppConst.IntNull)
{
parameters[5].Value = model.Love;
}
else
{
parameters[5].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[5]);
if (model.Hate != AppConst.IntNull)
{
parameters[6].Value = model.Hate;
}
else
{
parameters[6].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[6]);
if (model.DR != AppConst.IntNull)
{
parameters[7].Value = model.DR;
}
else
{
parameters[7].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[7]);
if (model.TS != AppConst.DateTimeNull)
{
parameters[8].Value = model.TS;
}
else
{
parameters[8].Value = System.DBNull.Value;
}
cmd.Parameters.Add(parameters[8]);
return(SqlHelper.ExecuteNonQuery(cmd, parameters));
}
public int DeleteLibrary()
{
return(SqlHelper.ExecuteNonQuery(Con, CommandType.Text, @"Delete from [ttcisg127200]
WHERE t_lbcd= '" + LibraryCode + @"'"));
}
public void DeleteById(int id)
{
SqlHelper.ExecuteNonQuery("delete from DD_Customer where AutoId=@id",
new SqlParameter("@id", id));
}
/// <summary>
/// Removes the Xml cached in the database - unpublish and cleaning
/// </summary>
public virtual void XmlRemoveFromDB()
{
SqlHelper.ExecuteNonQuery("delete from cmsContentXml where nodeId = @nodeId", SqlHelper.CreateParameter("@nodeId", this.Id));
}
public static int DeleteCategory()
{
var sql = @"TRUNCATE TABLE Category";
return(SqlHelper.ExecuteNonQuery(con, CommandType.Text, sql));
}
public static int UpdateAvName(string name, int id)
{
var sql = @"UPDATE AV SET Name = '" + name + "' WHERE AvId = " + id;
return(SqlHelper.ExecuteNonQuery(con, CommandType.Text, sql));
}
public int DeletePurpose()
{
return(SqlHelper.ExecuteNonQuery(Con, CommandType.Text, @"Delete from [ttcisg129200]
WHERE t_prcd= '" + PurposeCode + @"'"));
}
/// <summary>
/// Creates a new Content object from the ContentType.
/// </summary>
/// <param name="ct"></param>
protected void CreateContent(ContentType ct)
{
SqlHelper.ExecuteNonQuery("insert into cmsContent (nodeId,ContentType) values (" + this.Id + "," + ct.Id + ")");
createNewVersion();
}
public int DeleteDatabase()
{
return(SqlHelper.ExecuteNonQuery(Con, CommandType.Text, @"Delete from [ttcisg128200]
WHERE t_dbid= '" + DBID + @"'"));
}
public int DeleteHandle()
{
return(SqlHelper.ExecuteNonQuery(Con, CommandType.Text, @"Delete from [ttcisg130200]
WHERE t_hndl= '" + AttachmentHandle + @"'"));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(string Id)
{
string strSQL = String.Format("delete from T_SYS_USER_PROXY where ID='{0}'", Id);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
public static int InsertJavBusCategory(string javBusCategory, string javLibCategory)
{
var sql = @"INSERT INTO JavBusCategoryMapping (JavBusCategory, JavLibCategory) VALUES ('" + javBusCategory + "', '" + javLibCategory + "')";
return(SqlHelper.ExecuteNonQuery(con, CommandType.Text, sql));
}