参数化查询 '(@MNum varchar(50),@MName,'需要参数 '@MContent'，但未提供该参数。

[wujing7390]

参数化查询 '(@MNum varchar(50),@MName varchar(50),@MSex int,@MBirthday datet' 需要参数 '@MContent'，但未提供该参数。


public int Member_Add(MyZoneOA.Model.OA.Member.Member model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Member(");
strSql.Append("MNum,MName,MSex,MBirthday,MNumberID,DeptID,HAQTID,MBirthPlace,HRPTID,MTID,MWorkTime,MInTime,MHID,MModelWorker,MSSN,MResume,MContent,MState)");
strSql.Append(" values (");
strSql.Append("@MNum,@MName,@MSex,@MBirthday,@MNumberID,@DeptID,@HAQTID,@MBirthPlace,@HRPTID,@MTID,@MWorkTime,@MInTime,@MHID,@MModelWorker,@MSSN,@MResume,@MContent,@MState)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@MNum", SqlDbType.VarChar,50),
new SqlParameter("@MName", SqlDbType.VarChar,50),
new SqlParameter("@MSex", SqlDbType.Int,4),
new SqlParameter("@MBirthday", SqlDbType.DateTime),
new SqlParameter("@MNumberID", SqlDbType.VarChar,50),
new SqlParameter("@DeptID", SqlDbType.Int,4),
new SqlParameter("@HAQTID", SqlDbType.Int,4),
new SqlParameter("@MBirthPlace", SqlDbType.VarChar,50),
new SqlParameter("@HRPTID", SqlDbType.Int,4),
new SqlParameter("@MTID", SqlDbType.Int,4),
new SqlParameter("@MWorkTime", SqlDbType.DateTime),
new SqlParameter("@MInTime", SqlDbType.DateTime),
new SqlParameter("@MHID", SqlDbType.Int,4),
new SqlParameter("@MModelWorker", SqlDbType.VarChar,50),
new SqlParameter("@MSSN", SqlDbType.VarChar,50),
new SqlParameter("@MResume", SqlDbType.VarChar,2000),
new SqlParameter("@MContent", SqlDbType.VarChar,2000),
new SqlParameter("@MState", SqlDbType.Int,4)};
parameters[0].Value = model.MNum;
parameters[1].Value = model.MName;
parameters[2].Value = model.MSex;
parameters[3].Value = model.MBirthday;
parameters[4].Value = model.MNumberID;
parameters[5].Value = model.DeptID;
parameters[6].Value = model.HAQTID;
parameters[7].Value = model.MBirthPlace;
parameters[8].Value = model.HRPTID;
parameters[9].Value = model.MTID;
parameters[10].Value = model.MWorkTime;
parameters[11].Value = model.MInTime;
parameters[12].Value = model.MHID;
parameters[13].Value = model.MModelWorker;
parameters[14].Value = model.MSSN;
parameters[15].Value = model.MResume;
parameters[15].Value = model.MContent;
parameters[17].Value = model.MState;

object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}

[wujing7390]

public static object GetSingle(string SQLString, params SqlParameter[] cmdParms)
{
using (SqlConnection connection = new SqlConnection(ConnectionStringLocalTransaction))
{
using (SqlCommand cmd = new SqlCommand())
{
try
{
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
object obj = cmd.ExecuteScalar();
cmd.Parameters.Clear();
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
return null;
}
else
{
return obj;
}
}
catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
connection.Close();
}
}
}
}

[wujing7390]

private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, string cmdText, SqlParameter[] cmdParms)
{
if (conn.State != ConnectionState.Open)
conn.Open();
cmd.Connection = conn;
cmd.CommandText = cmdText;
if (trans != null)
cmd.Transaction = trans;
cmd.CommandType = CommandType.Text;//cmdType;
if (cmdParms != null)
{
foreach (SqlParameter parm in cmdParms)
cmd.Parameters.Add(parm);
}
}

[wujing7390]

传值
MyZoneOA.Model.OA.Member.Member model = new MyZoneOA.Model.OA.Member.Member();
model.MNum = this.TMNum.Text.Trim();
model.MName = this.TMName.Text.Trim();
model.MSex = Convert.ToInt32(this.radl_MSex.SelectedItem.Value.ToString());
if (this.TMBirthday.Value.Trim() != "")
{
model.MBirthday = Convert.ToDateTime(this.TMBirthday.Value.Trim());
}
else
{
model.MBirthday = Convert.ToDateTime("1900-01-01");
}
model.MNumberID = this.TMNumberID.Text.Trim();
model.DeptID = Convert.ToInt32(this.ddl_Dept.SelectedValue.Trim());
model.HAQTID = Convert.ToInt32(this.ddl_HAQTID.SelectedValue.Trim());
model.MBirthPlace = this.TMBirthPlace.Text.Trim();
model.HRPTID=Convert.ToInt32(this.ddl_HRPTID.SelectedValue.Trim());
model.MTID = Convert.ToInt32(this.ddl_MHID.SelectedValue.Trim());
if (this.TMWorkTime.Value.Trim() != "")
{
model.MWorkTime = Convert.ToDateTime(this.TMWorkTime.Value.Trim());
}
else
{
model.MWorkTime = Convert.ToDateTime("2010-01-01");
}
if (this.TMInTime.Value.Trim() != "")
{
model.MInTime = Convert.ToDateTime(this.TMInTime.Value.Trim());
}
else
{
model.MInTime = Convert.ToDateTime("2010-01-01");
}
model.MTID = Convert.ToInt32(this.ddl_Type.SelectedValue.Trim());
model.MModelWorker = this.TMModelWorker.Text.Trim();
model.MSSN = this.TMSSN.Text.Trim();
model.MResume = this.TMResume.Text.Trim();
model.MContent = this.TMContent.Text.Trim();
model.MState = Convert.ToInt32(this.ddl_MStates.SelectedValue.Trim());
try
{
MyZoneOA.BLL.sys.Common mycom = new MyZoneOA.BLL.sys.Common();
CurrentUser me = (CurrentUser)Session["me"];
if (Request["MID"].ToString() == "0")//新增
{

BLLMember.Member_Add(model);
//添加操作日志
mycom.SaveSys_OpLog(me.UserID.ToString(), me.RealName, "Member,Sys_User_Dept_Index", "添加会员:" + this.TMName.Text, Request.UserHostAddress.ToString());

}
else//修改
{
BLLMember.Member_Update(model);
//添加操作日志
mycom.SaveSys_OpLog(me.UserID.ToString(), me.RealName, "Member,Member_Health,Member_Type,Sys_User_Dept_Index", "修改会员:" + TMName.Text, Request.UserHostAddress.ToString());
}
string deptid = this.ddl_Dept.SelectedItem.Value.Trim();
Response.Redirect("Member_List.aspx?pageflag=true&DeptID=" + deptid + "", true);
}
catch
{
lbmsg.Text = "保存失败！";
return;
}

[qq346127416]

parameters[15].Value = model.MResume;
parameters[16].Value = model.MContent; //改16

[laowang134]

不是自动生成的么 还有错！~？

[moduofanchen]

[Quote=引用 4 楼 qq346127416 的回复:]

parameters[15].Value = model.MResume;
parameters[16].Value = model.MContent; //改16
[/Quote]
正解 你两个15