/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMC_CHAT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMC_CHAT set ");
strSql.Append("C_UID=:C_UID,");
strSql.Append("C_FID=:C_FID,");
strSql.Append("C_CONTENT=:C_CONTENT,");
strSql.Append("D_DT=:D_DT");
strSql.Append(" where C_ID=:C_ID");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_UID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CONTENT", OracleDbType.Varchar2, 200),
new OracleParameter(":D_DT", OracleDbType.Date)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_UID;
parameters[2].Value = model.C_FID;
parameters[3].Value = model.C_CONTENT;
parameters[4].Value = model.D_DT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMC_CHAT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMC_CHAT(");
strSql.Append("C_UID,C_FID,C_CONTENT)");
strSql.Append(" values (");
strSql.Append(":C_UID,:C_FID,:C_CONTENT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_UID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CONTENT", OracleDbType.Varchar2, 300)
};
parameters[0].Value = model.C_UID;
parameters[1].Value = model.C_FID;
parameters[2].Value = model.C_CONTENT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMC_CHAT DataRowToModel(DataRow row)
{
Mod_TMC_CHAT model = new Mod_TMC_CHAT();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_UID"] != null)
{
model.C_UID = row["C_UID"].ToString();
}
if (row["C_FID"] != null)
{
model.C_FID = row["C_FID"].ToString();
}
if (row["C_CONTENT"] != null)
{
model.C_CONTENT = row["C_CONTENT"].ToString();
}
if (row["D_DT"] != null && row["D_DT"].ToString() != "")
{
model.D_DT = DateTime.Parse(row["D_DT"].ToString());
}
}
return(model);
}
public AjaxResult ChatAddPC([FromBody] dynamic Json)
{
#region //接收参数
string fID = Json.fID; //接收者
string content = Json.content; //发送内容
#endregion
#region //数据操作
AjaxResult result = new AjaxResult();
var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (vUser != null)
{
Mod_TMC_CHAT mod = new Mod_TMC_CHAT();
mod.C_UID = vUser.Id;
mod.C_FID = fID;
mod.C_CONTENT = content;
if (tmc_chat.Add(mod))
{
result.Code = DoResult.Success;
result.Result = "提交成功";
}
else
{
result.Code = DoResult.Failed;
result.Result = "提交失败";
}
}
#endregion
return(result);
}
protected void btnInsert_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtContent.Value))
{
Mod_TMC_CHAT mod = new Mod_TMC_CHAT();
mod.C_UID = hidUserID.Value;
mod.C_FID = ltlUID.Text;
mod.C_CONTENT = txtContent.Value;
mod.D_DT = DateTime.Now;
if (tmc_chat.Add(mod))
{
GetChat();
}
}
}
public static bool SetChat(string content, string uid)
{
DataRow dr = tmc_chat_emp.GetChatEmp();
if (dr != null)
{
string fid = dr["c_user_id"].ToString();
Mod_TMC_CHAT mod = new Mod_TMC_CHAT();
mod.C_UID = uid;
mod.C_FID = fid;
mod.C_CONTENT = content;
mod.D_DT = DateTime.Now;
return(tmc_chat.Add(mod));
}
else
{
return(false);
}
}
public AjaxResult ChatAdd([FromBody] dynamic Json)
{
#region //接收参数
string Content = Json.Content; //发送内容
#endregion
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
#region //数据操作
DataRow dr = tmc_chat_emp.GetChatEmp();
if (dr != null)
{
Mod_TS_USER modUser = GetUserID();
string fid = dr["c_user_id"].ToString();
Mod_TMC_CHAT mod = new Mod_TMC_CHAT();
mod.C_UID = modUser.C_ID;
mod.C_FID = fid;
mod.C_CONTENT = Content;
mod.D_DT = DateTime.Now;
if (tmc_chat.Add(mod))
{
result.Result = "提交成功";
}
else
{
result.Result = "提交失败";
}
}
else
{
result.Result = "提交失败";
}
#endregion
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMC_CHAT GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_UID,C_FID,C_CONTENT,D_DT from TMC_CHAT ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
};
Mod_TMC_CHAT model = new Mod_TMC_CHAT();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMC_CHAT model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMC_CHAT model)
{
return(dal.Add(model));
}
